Remove-Isolate function

To apply any of functions like:

§          Remove-Isolate                     not MDX function, implementation of MDX Filter function

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … Remove or Isolate from submenu

 

 

In our case let us try to remove:

 

Guerrero, Jalisco, Mexico, Oaxaca, Sinaloa, Veracruz,  WA, DF from result

 

Dialog will appear:

 

 

·            define members to remove

o         select button Add

Ø       find  member(s)

Ø       select them

Ø       select Ok

 

·            select OK

 

 

When we set all parameters as we agreed, dialog will look like this:

 

 

After confirmation result is: